Features of MS Excel


 
 
Concept Explanation
 

Features of MS Excel

Microsoft Excel is an electronic spreadsheet package of MS office software suite. It is a Windows based  application package. It is quite useful in entering, editing, analyzing and storing of data. Arithmetic operations with numerical data such as addition, subtraction, multiplication and division can also be done with Excel. You can sort the numbers/characters according to some given criteria (like ascending, descending etc.) and solve simple financial, mathematical and statistical formulas.

Excel Features:

There are a number of features that are available in Excel to make your task easier. Some of the main features are:

1.You Can Insert a New Worksheets at Will:

- 1 to 3 default worksheets you might have seen, when you open the new workbook. You can insert a new worksheet in excel and delete the same at any point in time.

2. Time Saving Shortcut Keys: -

All the time you spend on excel can be reduced drastically by masterful excel shortcut keys. Apart from universal “Ctrl + C, Ctrl + X, and Ctrl + V,” we can use many other abundant shortcut keys in Excel.

3. AutoSum: -

If you have serial numbers or any numerical data, then you can quickly get the sum of these numbers with simple shortcut keys.

4. Filtering Data: -

Filtering the Excel data is one of the important features of Microsoft Excel. We can filter any data available under the filter section.

5. Paste Special Feature: -

It gives more edge to increase workplace productivity.

6. Insert Serial Numbers: -

If you want to insert serial numbers that are incremented by 1, then we can do this by simply fill the series option. Enter the value 1 in any of the cells. Now using Excel Fill Handle drag till the cell where you want to insert serial numbers.

.... (More Text Available, Login?)
Sample Questions
(More Questions for each concept available in Login)
Question : 1

In a worksheet in MS-Excel, short-cut key to hide entire row is _________ .

Right Option : C
View Explanation
Explanation
Question : 2

What is the shortcut key to create a new worksheet in an Excel workbook?

Right Option : A
View Explanation
Explanation
Question : 3

Insert date, format page number and insert auto text are buttons on the _________________ toolbar .

Right Option : B
View Explanation
Explanation
 
 


Students / Parents Reviews [20]